Dashboarding with Notebooks: NYC Housing Authority

An automated dashboard built to investigate structural patterns resulting from New York City & State transportation policy.

lines of questioning - EDA
how many riders of L train
how many cyclists
how many bus riders
refer to article predictions of where capacity will move to
present general transit trends maybe
show map of cyclist accidents?
show time-series trends of accidents
conclude with whether L train has increased accidents
leaflet timeline is difficult at best, consider gganimate
gganimate issues installing with R 3.5.1
oof

I was inspired by this CityLab article detailing the impending transportation crisis due to the MTA L Line shutdown. Specifically, I am interested in observing whether the shutdown contributes to an increase in cyclist injuries due to motor vehicle collisions as L Train riders seek alternatives.

I expect most people to shift to other public transit options as well as ride-sharing and hailing, and could investigate the dispersion of L Train riders to other options as a whole if data is available, but for now I will focus on cyclists (since the city certainly doesn’t).

Let’s start by looking at some performance metrics for the MTA subway network as a whole.

Next, the L Line specifically:

Now let’s compare the yearly average OTP between lines.

Now let’s look at some two-wheeled data.